CONTENTS About This Manual Who Should Read This Manual Organization Notational Conventions Icons Typography Associated Documents Registering Your Product Where to Get Help Telephone Technical Support International Technical Support Education and Training Product Information Professional Developers' Program CompuServe Forum Contacting Novell 1 Introduction to Btrieve Client-Server Design Btrieve Features Index Maintenance File Specifications Memory Management Data Integrity Security Controls Btrieve Enhancements Btrieve v6.1 Enhancements Support for Operating on a Portion of a Record: Chunks New Operations to Support Records Larger than 64 KB New File Structure to Support Very Long Records Multiple Alternate Collating Sequences Locale-Sensitive Collating Sequences Index Balancing Performing Reads While Creating an Index New Data Type Percentage Operations No Currency Change New Ability to Specify Repeating- or Linked-Duplicatable Keys on Create Operations Improved Btrieve Requesters Btrieve v6.x Enhancements New File Format Online Backups Shadow Paging New Caching Algorithm Better Usage of Large Data Files Up to 119 Key Segments Adding and Dropping Any Index Specific Key Numbers Allowed When Creating a File or Index Optional Renumbering of Keys Enhanced Support for Case-Insensitive KEys Enhancement to autoincrement Key Reserved Space for Duplicate Pointers Key-Only File Modification New Stat Option Locking in Extended Operations Support for Referential Integrity 2 Btrieve Architecture Components of Btrieve Server-Based Record Manager Communications Programs Btrieve Message Router BSPXCOM BSPXSTUB and RSPXSTUB Workstation Requesters Btrieve Utilities Btrieve Applications on a Server Server Application Accessing Local Data Server Application Accessing Remote Data Btrieve Applications on a Workstation Workstation Application Accessing Local Data Workstation Application Accessing Remote Data Workstation Application Accessing Local and Remote Data Examples of Btrieve Architecture Server Application Using the Btrieve NLM Server Application Using the Btrieve Message Router Server Application Using the Btrieve Message Router and BSPXCOM Workstation Application Using the Requester and Client-Based Btrieve Server Application Using RSPXSTUB Server Application Using BSPXSTUB Server Application Using NetWare SQL 3 Installing and Configuring Btrieve Installing Btrieve System Requirements Using the NetWare INSTALL Utility Configuring Btrieve Configuration Options Number of Open Files Number of Handles Number of Locks Number of Transactions Largest Compressed Record Size Largest Record Size Largest Page Size Number of Remote Sessions Cache Allocation Perform Index Balancing Logging of Selected Files Create Btrieve Files in Pre v6.x Format Create Files as Transactional Configure BSTART.NCF to Load BROUTER Running the Setup Utility Starting and Stopping Btrieve Checking for Extraneous Pre-Image Files Unloading the Earlier Version of Btrieve Starting Btrieve v6.x Stopping Btrieve v6.x Rebuilding Existing Btrieve Files Running the Rebuild Utility Interactively Configuring the Rebuild Utility Executing the Rebuild Utility Checking the Rebuild Log File Running the Rebuild Utility from the Command Line Deleting Temporary Files Using Btrieve with NetWare Runtime Reasons to Use NetWare Runtime Installing NetWare Runtime Special Notes on NetWare Runtime Special Notes on Btrieve 4 Configuring and Using the Requesters DOS Requester DOS Requester Configuration Options NetWare Runtime Server Support (/C) Data Message Length (/D) DOS Session Load (/L) Real-Time Data Compression (/O) Help (/?) Loading the DOS Requester Unloading the DOS Requester OS/2 Requester OS/2 Requester Configuration Options NetWare Runtime Server Support (/C) Data Message Length (/D) Number of Servers (/S) Configuring the OS/2 Requester Loading the OS/2 Requester Unloading the OS/2 Requester Windows Requester Windows Requester Configuration Options Loading the Windows Requester Unloading the Windows Requester 5 Using Btrieve Utilities Btrieve Monitor Utility System Requirements Starting the Monitor Utility Monitoring Btrieve Files with the Active Resources Option Listing Active Files Displaying Additional Information About an Active File Listing Users Accessing a File Monitoring Btrieve Users with the User Information Option Listing All Users Listing Files Accessed by a User Deleting User Connections Monitoring Resources with the Resource Usage Option Monitoring SPX Activity with the Communication Statistics Option Btrieve Maintenance Utility Utility Overview Command Format Concepts Command Files Maintenance Utility Commands CLONE CLROWNER COPY CREATE DROP ENDBU INDEX LOAD RECOVER SALVAGE SAVE SETOWNER SINDEX STARTBU STAT VER Roll Forward Utility Setting Up Files for Logging Activating the Btrieve Logging Option Creating the Log Configuration File Backing Up Data Files Running the Roll Forward Utility in a DOS Environment Running the Roll Forward Utility in an OS/2 or Windows Environment Using the Roll Forward Pulldown Menus Setting Options for the Roll Forward Utility Placing Items in the Queue Rolling Forward Items in the Queue A Description Files Rules for Description Files Description File Example Description File Elements B Status Codes and Messages Status Codes Messages Glossary Index